<?php
/**
 * Model for database-specific MySQL queries
 */
class MySQLDatabaseQuery extends AbstractSQLDatabaseQuery {
	/**
	 * Gets tables in database
	 * 
	 * @return string
	 */
	public function getTables() {
		return "SHOW TABLES IN ".$this->strDatabaseName;
	}
	
	/**
	 * Creates current database
	 * 
	 * @return string
	 */
	public function create() {
		return "CREATE DATABASE ".$this->strDatabaseName;
	}
	
	/**
	 * Renames current database.
	 * 
	 * @param string $newDatabaseName
	 * @return string
	 */
	public function rename($newDatabaseName) {
		return "RENAME DATABASE ".$this->strDatabaseName." TO ".$newDatabaseName;
	}
	
	/**
	 * Drops current database
	 * 
	 * @return string
	 */
	public function drop() {
		return "DROP DATABASE ".$this->strDatabaseName;
	}
}